from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class BaseinfoNormal(Base):
    __tablename__ = "TYC_IC_BASEINFO_NORMAL"
    HISTORYNAMES = Column(String(255))
    CANCELDATE = Column(String(255))
    REGSTATUS = Column(String(255))
    REGCAPITAL = Column(String(255))
    CITY = Column(String(255))
    STAFFNUMRANGE = Column(String(255))
    BONDNUM = Column(String(255))
    HISTORYNAMELIST = Column(String(255))
    INDUSTRY = Column(String(255))
    BONDNAME = Column(String(255))
    REVOKEDATE = Column(String(255))
    TYPE = Column(Integer)
    UPDATETIMES = Column(Integer)
    LEGALPERSONNAME = Column(String(255))
    REVOKEREASON = Column(String(500))
    COMPFORM = Column(String(255))
    REGNUMBER = Column(String(255))
    CREDITCODE = Column(String(255))
    PROPERTY3 = Column(String(255))
    USEDBONDNAME = Column(String(255))
    APPROVEDTIME = Column(Integer)
    FROMTIME = Column(Integer)
    SOCIALSTAFFNUM = Column(Integer)
    ACTUALCAPITALCURRENCY = Column(String(255))
    ALIAS = Column(String(255))
    COMPANYORGTYPE = Column(String(255))
    ID = Column(Integer, primary_key=True)
    CANCELREASON = Column(String(500))
    ORGNUMBER = Column(String(255))
    TOTIME = Column(String(255))
    ACTUALCAPITAL = Column(String(255))
    ESTIBLISHTIME = Column(Integer)
    REGINSTITUTE = Column(String(255))
    BUSINESSSCOPE = Column(String(4000))
    TAXNUMBER = Column(String(255))
    REGLOCATION = Column(String(255))
    REGCAPITALCURRENCY = Column(String(255))
    TAGS = Column(String(255))
    DISTRICT = Column(String(255))
    BONDTYPE = Column(String(255))
    NAME = Column(String(255))
    PERCENTILESCORE = Column(Integer)
    INDUSTRYALL = Column(Text())
    ISMICROENT = Column(Integer)
    BASE = Column(String(255))
    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)